﻿using System;
using System.Data;
using System.Text;
using System.Data.OracleClient;
using DBUtility;//Please add references
namespace TierApplication
{
	/// <summary>
	/// 类T_ALIPAYNOTIFYSYN。
	/// </summary>
	[Serializable]
	public partial class T_ALIPAYNOTIFYSYN
	{
		public T_ALIPAYNOTIFYSYN()
		{}
		#region Model
		private string _notifysynid;
		private string _is_success;
		private string _sign_type;
		private string _sign;
		private string _out_trade_no;
		private string _subject;
		private string _payment_type;
		private string _exterface;
		private string _trade_no;
		private string _trade_status;
		private string _notify_id;
		private DateTime? _notify_time;
		private string _notify_type;
		private string _seller_email;
		private string _buyer_email;
		private string _seller_id;
		private string _buyer_id;
		private decimal? _total_fee;
		private string _body;
		private string _extra_common_param;
		/// <summary>
		/// 序列号
		/// </summary>
		public string NOTIFYSYNID
		{
			set{ _notifysynid=value;}
			get{return _notifysynid;}
		}
		/// <summary>
		/// 成功标识
		/// </summary>
		public string IS_SUCCESS
		{
			set{ _is_success=value;}
			get{return _is_success;}
		}
		/// <summary>
		/// 签名方式
		/// </summary>
		public string SIGN_TYPE
		{
			set{ _sign_type=value;}
			get{return _sign_type;}
		}
		/// <summary>
		/// 签名
		/// </summary>
		public string SIGN
		{
			set{ _sign=value;}
			get{return _sign;}
		}
		/// <summary>
		/// 商户网站唯一订单号
		/// </summary>
		public string OUT_TRADE_NO
		{
			set{ _out_trade_no=value;}
			get{return _out_trade_no;}
		}
		/// <summary>
		/// 商品名称
		/// </summary>
		public string SUBJECT
		{
			set{ _subject=value;}
			get{return _subject;}
		}
		/// <summary>
		/// 支付类型
		/// </summary>
		public string PAYMENT_TYPE
		{
			set{ _payment_type=value;}
			get{return _payment_type;}
		}
		/// <summary>
		/// 接口名称
		/// </summary>
		public string EXTERFACE
		{
			set{ _exterface=value;}
			get{return _exterface;}
		}
		/// <summary>
		/// 支付宝交易号
		/// </summary>
		public string TRADE_NO
		{
			set{ _trade_no=value;}
			get{return _trade_no;}
		}
		/// <summary>
		/// 交易状态
		/// </summary>
		public string TRADE_STATUS
		{
			set{ _trade_status=value;}
			get{return _trade_status;}
		}
		/// <summary>
		/// 通知校验ID
		/// </summary>
		public string NOTIFY_ID
		{
			set{ _notify_id=value;}
			get{return _notify_id;}
		}
		/// <summary>
		/// 通知时间
		/// </summary>
		public DateTime? NOTIFY_TIME
		{
			set{ _notify_time=value;}
			get{return _notify_time;}
		}
		/// <summary>
		/// 通知类型
		/// </summary>
		public string NOTIFY_TYPE
		{
			set{ _notify_type=value;}
			get{return _notify_type;}
		}
		/// <summary>
		/// 卖家支付宝账号
		/// </summary>
		public string SELLER_EMAIL
		{
			set{ _seller_email=value;}
			get{return _seller_email;}
		}
		/// <summary>
		/// 买家支付宝账号
		/// </summary>
		public string BUYER_EMAIL
		{
			set{ _buyer_email=value;}
			get{return _buyer_email;}
		}
		/// <summary>
		/// 卖家支付宝账户号
		/// </summary>
		public string SELLER_ID
		{
			set{ _seller_id=value;}
			get{return _seller_id;}
		}
		/// <summary>
		/// 买家支付宝账户号
		/// </summary>
		public string BUYER_ID
		{
			set{ _buyer_id=value;}
			get{return _buyer_id;}
		}
		/// <summary>
		/// 交易金额
		/// </summary>
		public decimal? TOTAL_FEE
		{
			set{ _total_fee=value;}
			get{return _total_fee;}
		}
		/// <summary>
		/// 商品描述
		/// </summary>
		public string BODY
		{
			set{ _body=value;}
			get{return _body;}
		}
		/// <summary>
		/// 公用回传参数
		/// </summary>
		public string EXTRA_COMMON_PARAM
		{
			set{ _extra_common_param=value;}
			get{return _extra_common_param;}
		}
		#endregion Model


		#region  Method

		/// <summary>
		/// 得到一个对象实体
		/// </summary>
		public T_ALIPAYNOTIFYSYN(string NOTIFYSYNID)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select NOTIFYSYNID,IS_SUCCESS,SIGN_TYPE,SIGN,OUT_TRADE_NO,SUBJECT,PAYMENT_TYPE,EXTERFACE,TRADE_NO,TRADE_STATUS,NOTIFY_ID,NOTIFY_TIME,NOTIFY_TYPE,SELLER_EMAIL,BUYER_EMAIL,SELLER_ID,BUYER_ID,TOTAL_FEE,BODY,EXTRA_COMMON_PARAM ");
			strSql.Append(" FROM T_ALIPAYNOTIFYSYN ");
			strSql.Append(" where NOTIFYSYNID=:NOTIFYSYNID ");
			OracleParameter[] parameters = {
					new OracleParameter(":NOTIFYSYNID", OracleType.VarChar,50)};
			parameters[0].Value = NOTIFYSYNID;

			DataSet ds=DbHelperOra.Query(strSql.ToString(),parameters);
			if(ds.Tables[0].Rows.Count>0)
			{
				if(ds.Tables[0].Rows[0]["NOTIFYSYNID"]!=null && ds.Tables[0].Rows[0]["NOTIFYSYNID"].ToString()!="")
				{
					this.NOTIFYSYNID=ds.Tables[0].Rows[0]["NOTIFYSYNID"].ToString();
				}
				if(ds.Tables[0].Rows[0]["IS_SUCCESS"]!=null && ds.Tables[0].Rows[0]["IS_SUCCESS"].ToString()!="")
				{
					this.IS_SUCCESS=ds.Tables[0].Rows[0]["IS_SUCCESS"].ToString();
				}
				if(ds.Tables[0].Rows[0]["SIGN_TYPE"]!=null && ds.Tables[0].Rows[0]["SIGN_TYPE"].ToString()!="")
				{
					this.SIGN_TYPE=ds.Tables[0].Rows[0]["SIGN_TYPE"].ToString();
				}
				if(ds.Tables[0].Rows[0]["SIGN"]!=null && ds.Tables[0].Rows[0]["SIGN"].ToString()!="")
				{
					this.SIGN=ds.Tables[0].Rows[0]["SIGN"].ToString();
				}
				if(ds.Tables[0].Rows[0]["OUT_TRADE_NO"]!=null && ds.Tables[0].Rows[0]["OUT_TRADE_NO"].ToString()!="")
				{
					this.OUT_TRADE_NO=ds.Tables[0].Rows[0]["OUT_TRADE_NO"].ToString();
				}
				if(ds.Tables[0].Rows[0]["SUBJECT"]!=null && ds.Tables[0].Rows[0]["SUBJECT"].ToString()!="")
				{
					this.SUBJECT=ds.Tables[0].Rows[0]["SUBJECT"].ToString();
				}
				if(ds.Tables[0].Rows[0]["PAYMENT_TYPE"]!=null && ds.Tables[0].Rows[0]["PAYMENT_TYPE"].ToString()!="")
				{
					this.PAYMENT_TYPE=ds.Tables[0].Rows[0]["PAYMENT_TYPE"].ToString();
				}
				if(ds.Tables[0].Rows[0]["EXTERFACE"]!=null && ds.Tables[0].Rows[0]["EXTERFACE"].ToString()!="")
				{
					this.EXTERFACE=ds.Tables[0].Rows[0]["EXTERFACE"].ToString();
				}
				if(ds.Tables[0].Rows[0]["TRADE_NO"]!=null && ds.Tables[0].Rows[0]["TRADE_NO"].ToString()!="")
				{
					this.TRADE_NO=ds.Tables[0].Rows[0]["TRADE_NO"].ToString();
				}
				if(ds.Tables[0].Rows[0]["TRADE_STATUS"]!=null && ds.Tables[0].Rows[0]["TRADE_STATUS"].ToString()!="")
				{
					this.TRADE_STATUS=ds.Tables[0].Rows[0]["TRADE_STATUS"].ToString();
				}
				if(ds.Tables[0].Rows[0]["NOTIFY_ID"]!=null && ds.Tables[0].Rows[0]["NOTIFY_ID"].ToString()!="")
				{
					this.NOTIFY_ID=ds.Tables[0].Rows[0]["NOTIFY_ID"].ToString();
				}
				if(ds.Tables[0].Rows[0]["NOTIFY_TIME"]!=null && ds.Tables[0].Rows[0]["NOTIFY_TIME"].ToString()!="")
				{
					this.NOTIFY_TIME=DateTime.Parse(ds.Tables[0].Rows[0]["NOTIFY_TIME"].ToString());
				}
				if(ds.Tables[0].Rows[0]["NOTIFY_TYPE"]!=null && ds.Tables[0].Rows[0]["NOTIFY_TYPE"].ToString()!="")
				{
					this.NOTIFY_TYPE=ds.Tables[0].Rows[0]["NOTIFY_TYPE"].ToString();
				}
				if(ds.Tables[0].Rows[0]["SELLER_EMAIL"]!=null && ds.Tables[0].Rows[0]["SELLER_EMAIL"].ToString()!="")
				{
					this.SELLER_EMAIL=ds.Tables[0].Rows[0]["SELLER_EMAIL"].ToString();
				}
				if(ds.Tables[0].Rows[0]["BUYER_EMAIL"]!=null && ds.Tables[0].Rows[0]["BUYER_EMAIL"].ToString()!="")
				{
					this.BUYER_EMAIL=ds.Tables[0].Rows[0]["BUYER_EMAIL"].ToString();
				}
				if(ds.Tables[0].Rows[0]["SELLER_ID"]!=null && ds.Tables[0].Rows[0]["SELLER_ID"].ToString()!="")
				{
					this.SELLER_ID=ds.Tables[0].Rows[0]["SELLER_ID"].ToString();
				}
				if(ds.Tables[0].Rows[0]["BUYER_ID"]!=null && ds.Tables[0].Rows[0]["BUYER_ID"].ToString()!="")
				{
					this.BUYER_ID=ds.Tables[0].Rows[0]["BUYER_ID"].ToString();
				}
				if(ds.Tables[0].Rows[0]["TOTAL_FEE"]!=null && ds.Tables[0].Rows[0]["TOTAL_FEE"].ToString()!="")
				{
					this.TOTAL_FEE=decimal.Parse(ds.Tables[0].Rows[0]["TOTAL_FEE"].ToString());
				}
				if(ds.Tables[0].Rows[0]["BODY"]!=null && ds.Tables[0].Rows[0]["BODY"].ToString()!="")
				{
					this.BODY=ds.Tables[0].Rows[0]["BODY"].ToString();
				}
				if(ds.Tables[0].Rows[0]["EXTRA_COMMON_PARAM"]!=null && ds.Tables[0].Rows[0]["EXTRA_COMMON_PARAM"].ToString()!="")
				{
					this.EXTRA_COMMON_PARAM=ds.Tables[0].Rows[0]["EXTRA_COMMON_PARAM"].ToString();
				}
			}
		}

		/// <summary>
		/// 是否存在该记录
		/// </summary>
		public bool Exists(string NOTIFYSYNID)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select count(1) from T_ALIPAYNOTIFYSYN");
			strSql.Append(" where NOTIFYSYNID=:NOTIFYSYNID ");

			OracleParameter[] parameters = {
					new OracleParameter(":NOTIFYSYNID", OracleType.VarChar,50)};
			parameters[0].Value = NOTIFYSYNID;

			return DbHelperOra.Exists(strSql.ToString(),parameters);
		}


		/// <summary>
		/// 增加一条数据
		/// </summary>
		public void Add()
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("insert into T_ALIPAYNOTIFYSYN (");
			strSql.Append("NOTIFYSYNID,IS_SUCCESS,SIGN_TYPE,SIGN,OUT_TRADE_NO,SUBJECT,PAYMENT_TYPE,EXTERFACE,TRADE_NO,TRADE_STATUS,NOTIFY_ID,NOTIFY_TIME,NOTIFY_TYPE,SELLER_EMAIL,BUYER_EMAIL,SELLER_ID,BUYER_ID,TOTAL_FEE,BODY,EXTRA_COMMON_PARAM)");
			strSql.Append(" values (");
			strSql.Append(":NOTIFYSYNID,:IS_SUCCESS,:SIGN_TYPE,:SIGN,:OUT_TRADE_NO,:SUBJECT,:PAYMENT_TYPE,:EXTERFACE,:TRADE_NO,:TRADE_STATUS,:NOTIFY_ID,:NOTIFY_TIME,:NOTIFY_TYPE,:SELLER_EMAIL,:BUYER_EMAIL,:SELLER_ID,:BUYER_ID,:TOTAL_FEE,:BODY,:EXTRA_COMMON_PARAM)");
			OracleParameter[] parameters = {
					new OracleParameter(":NOTIFYSYNID", OracleType.VarChar,10),
					new OracleParameter(":IS_SUCCESS", OracleType.VarChar,1),
					new OracleParameter(":SIGN_TYPE", OracleType.VarChar,100),
					new OracleParameter(":SIGN", OracleType.VarChar,32),
					new OracleParameter(":OUT_TRADE_NO", OracleType.VarChar,64),
					new OracleParameter(":SUBJECT", OracleType.VarChar,256),
					new OracleParameter(":PAYMENT_TYPE", OracleType.VarChar,4),
					new OracleParameter(":EXTERFACE", OracleType.VarChar,100),
					new OracleParameter(":TRADE_NO", OracleType.VarChar,16),
					new OracleParameter(":TRADE_STATUS", OracleType.VarChar,100),
					new OracleParameter(":NOTIFY_ID", OracleType.VarChar,100),
					new OracleParameter(":NOTIFY_TIME", OracleType.DateTime),
					new OracleParameter(":NOTIFY_TYPE", OracleType.VarChar,100),
					new OracleParameter(":SELLER_EMAIL", OracleType.VarChar,100),
					new OracleParameter(":BUYER_EMAIL", OracleType.VarChar,100),
					new OracleParameter(":SELLER_ID", OracleType.VarChar,30),
					new OracleParameter(":BUYER_ID", OracleType.VarChar,30),
					new OracleParameter(":TOTAL_FEE", OracleType.Number,12),
					new OracleParameter(":BODY", OracleType.VarChar,400),
					new OracleParameter(":EXTRA_COMMON_PARAM", OracleType.VarChar,100)};
			parameters[0].Value = NOTIFYSYNID;
			parameters[1].Value = IS_SUCCESS;
			parameters[2].Value = SIGN_TYPE;
			parameters[3].Value = SIGN;
			parameters[4].Value = OUT_TRADE_NO;
			parameters[5].Value = SUBJECT;
			parameters[6].Value = PAYMENT_TYPE;
			parameters[7].Value = EXTERFACE;
			parameters[8].Value = TRADE_NO;
			parameters[9].Value = TRADE_STATUS;
			parameters[10].Value = NOTIFY_ID;
			parameters[11].Value = NOTIFY_TIME;
			parameters[12].Value = NOTIFY_TYPE;
			parameters[13].Value = SELLER_EMAIL;
			parameters[14].Value = BUYER_EMAIL;
			parameters[15].Value = SELLER_ID;
			parameters[16].Value = BUYER_ID;
			parameters[17].Value = TOTAL_FEE;
			parameters[18].Value = BODY;
			parameters[19].Value = EXTRA_COMMON_PARAM;

			DbHelperOra.ExecuteSql(strSql.ToString(),parameters);
		}
		/// <summary>
		/// 更新一条数据
		/// </summary>
		public bool Update()
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("update T_ALIPAYNOTIFYSYN set ");
			strSql.Append("IS_SUCCESS=:IS_SUCCESS,");
			strSql.Append("SIGN_TYPE=:SIGN_TYPE,");
			strSql.Append("SIGN=:SIGN,");
			strSql.Append("OUT_TRADE_NO=:OUT_TRADE_NO,");
			strSql.Append("SUBJECT=:SUBJECT,");
			strSql.Append("PAYMENT_TYPE=:PAYMENT_TYPE,");
			strSql.Append("EXTERFACE=:EXTERFACE,");
			strSql.Append("TRADE_NO=:TRADE_NO,");
			strSql.Append("TRADE_STATUS=:TRADE_STATUS,");
			strSql.Append("NOTIFY_ID=:NOTIFY_ID,");
			strSql.Append("NOTIFY_TIME=:NOTIFY_TIME,");
			strSql.Append("NOTIFY_TYPE=:NOTIFY_TYPE,");
			strSql.Append("SELLER_EMAIL=:SELLER_EMAIL,");
			strSql.Append("BUYER_EMAIL=:BUYER_EMAIL,");
			strSql.Append("SELLER_ID=:SELLER_ID,");
			strSql.Append("BUYER_ID=:BUYER_ID,");
			strSql.Append("TOTAL_FEE=:TOTAL_FEE,");
			strSql.Append("BODY=:BODY,");
			strSql.Append("EXTRA_COMMON_PARAM=:EXTRA_COMMON_PARAM");
			strSql.Append(" where NOTIFYSYNID=:NOTIFYSYNID ");
			OracleParameter[] parameters = {
					new OracleParameter(":IS_SUCCESS", OracleType.VarChar,1),
					new OracleParameter(":SIGN_TYPE", OracleType.VarChar,100),
					new OracleParameter(":SIGN", OracleType.VarChar,32),
					new OracleParameter(":OUT_TRADE_NO", OracleType.VarChar,64),
					new OracleParameter(":SUBJECT", OracleType.VarChar,256),
					new OracleParameter(":PAYMENT_TYPE", OracleType.VarChar,4),
					new OracleParameter(":EXTERFACE", OracleType.VarChar,100),
					new OracleParameter(":TRADE_NO", OracleType.VarChar,16),
					new OracleParameter(":TRADE_STATUS", OracleType.VarChar,100),
					new OracleParameter(":NOTIFY_ID", OracleType.VarChar,100),
					new OracleParameter(":NOTIFY_TIME", OracleType.DateTime),
					new OracleParameter(":NOTIFY_TYPE", OracleType.VarChar,100),
					new OracleParameter(":SELLER_EMAIL", OracleType.VarChar,100),
					new OracleParameter(":BUYER_EMAIL", OracleType.VarChar,100),
					new OracleParameter(":SELLER_ID", OracleType.VarChar,30),
					new OracleParameter(":BUYER_ID", OracleType.VarChar,30),
					new OracleParameter(":TOTAL_FEE", OracleType.Number,12),
					new OracleParameter(":BODY", OracleType.VarChar,400),
					new OracleParameter(":EXTRA_COMMON_PARAM", OracleType.VarChar,100),
					new OracleParameter(":NOTIFYSYNID", OracleType.VarChar,10)};
			parameters[0].Value = IS_SUCCESS;
			parameters[1].Value = SIGN_TYPE;
			parameters[2].Value = SIGN;
			parameters[3].Value = OUT_TRADE_NO;
			parameters[4].Value = SUBJECT;
			parameters[5].Value = PAYMENT_TYPE;
			parameters[6].Value = EXTERFACE;
			parameters[7].Value = TRADE_NO;
			parameters[8].Value = TRADE_STATUS;
			parameters[9].Value = NOTIFY_ID;
			parameters[10].Value = NOTIFY_TIME;
			parameters[11].Value = NOTIFY_TYPE;
			parameters[12].Value = SELLER_EMAIL;
			parameters[13].Value = BUYER_EMAIL;
			parameters[14].Value = SELLER_ID;
			parameters[15].Value = BUYER_ID;
			parameters[16].Value = TOTAL_FEE;
			parameters[17].Value = BODY;
			parameters[18].Value = EXTRA_COMMON_PARAM;
			parameters[19].Value = NOTIFYSYNID;

			int rows=DbHelperOra.ExecuteSql(strSql.ToString(),parameters);
			if (rows > 0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}

		/// <summary>
		/// 删除一条数据
		/// </summary>
		public bool Delete(string NOTIFYSYNID)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("delete from T_ALIPAYNOTIFYSYN ");
			strSql.Append(" where NOTIFYSYNID=:NOTIFYSYNID ");
			OracleParameter[] parameters = {
					new OracleParameter(":NOTIFYSYNID", OracleType.VarChar,50)};
			parameters[0].Value = NOTIFYSYNID;

			int rows=DbHelperOra.ExecuteSql(strSql.ToString(),parameters);
			if (rows > 0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}


		/// <summary>
		/// 得到一个对象实体
		/// </summary>
		public void GetModel(string NOTIFYSYNID)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select NOTIFYSYNID,IS_SUCCESS,SIGN_TYPE,SIGN,OUT_TRADE_NO,SUBJECT,PAYMENT_TYPE,EXTERFACE,TRADE_NO,TRADE_STATUS,NOTIFY_ID,NOTIFY_TIME,NOTIFY_TYPE,SELLER_EMAIL,BUYER_EMAIL,SELLER_ID,BUYER_ID,TOTAL_FEE,BODY,EXTRA_COMMON_PARAM ");
			strSql.Append(" FROM T_ALIPAYNOTIFYSYN ");
			strSql.Append(" where NOTIFYSYNID=:NOTIFYSYNID ");
			OracleParameter[] parameters = {
					new OracleParameter(":NOTIFYSYNID", OracleType.VarChar,50)};
			parameters[0].Value = NOTIFYSYNID;

			DataSet ds=DbHelperOra.Query(strSql.ToString(),parameters);
			if(ds.Tables[0].Rows.Count>0)
			{
				if(ds.Tables[0].Rows[0]["NOTIFYSYNID"]!=null && ds.Tables[0].Rows[0]["NOTIFYSYNID"].ToString()!="")
				{
					this.NOTIFYSYNID=ds.Tables[0].Rows[0]["NOTIFYSYNID"].ToString();
				}
				if(ds.Tables[0].Rows[0]["IS_SUCCESS"]!=null && ds.Tables[0].Rows[0]["IS_SUCCESS"].ToString()!="")
				{
					this.IS_SUCCESS=ds.Tables[0].Rows[0]["IS_SUCCESS"].ToString();
				}
				if(ds.Tables[0].Rows[0]["SIGN_TYPE"]!=null && ds.Tables[0].Rows[0]["SIGN_TYPE"].ToString()!="")
				{
					this.SIGN_TYPE=ds.Tables[0].Rows[0]["SIGN_TYPE"].ToString();
				}
				if(ds.Tables[0].Rows[0]["SIGN"]!=null && ds.Tables[0].Rows[0]["SIGN"].ToString()!="")
				{
					this.SIGN=ds.Tables[0].Rows[0]["SIGN"].ToString();
				}
				if(ds.Tables[0].Rows[0]["OUT_TRADE_NO"]!=null && ds.Tables[0].Rows[0]["OUT_TRADE_NO"].ToString()!="")
				{
					this.OUT_TRADE_NO=ds.Tables[0].Rows[0]["OUT_TRADE_NO"].ToString();
				}
				if(ds.Tables[0].Rows[0]["SUBJECT"]!=null && ds.Tables[0].Rows[0]["SUBJECT"].ToString()!="")
				{
					this.SUBJECT=ds.Tables[0].Rows[0]["SUBJECT"].ToString();
				}
				if(ds.Tables[0].Rows[0]["PAYMENT_TYPE"]!=null && ds.Tables[0].Rows[0]["PAYMENT_TYPE"].ToString()!="")
				{
					this.PAYMENT_TYPE=ds.Tables[0].Rows[0]["PAYMENT_TYPE"].ToString();
				}
				if(ds.Tables[0].Rows[0]["EXTERFACE"]!=null && ds.Tables[0].Rows[0]["EXTERFACE"].ToString()!="")
				{
					this.EXTERFACE=ds.Tables[0].Rows[0]["EXTERFACE"].ToString();
				}
				if(ds.Tables[0].Rows[0]["TRADE_NO"]!=null && ds.Tables[0].Rows[0]["TRADE_NO"].ToString()!="")
				{
					this.TRADE_NO=ds.Tables[0].Rows[0]["TRADE_NO"].ToString();
				}
				if(ds.Tables[0].Rows[0]["TRADE_STATUS"]!=null && ds.Tables[0].Rows[0]["TRADE_STATUS"].ToString()!="")
				{
					this.TRADE_STATUS=ds.Tables[0].Rows[0]["TRADE_STATUS"].ToString();
				}
				if(ds.Tables[0].Rows[0]["NOTIFY_ID"]!=null && ds.Tables[0].Rows[0]["NOTIFY_ID"].ToString()!="")
				{
					this.NOTIFY_ID=ds.Tables[0].Rows[0]["NOTIFY_ID"].ToString();
				}
				if(ds.Tables[0].Rows[0]["NOTIFY_TIME"]!=null && ds.Tables[0].Rows[0]["NOTIFY_TIME"].ToString()!="")
				{
					this.NOTIFY_TIME=DateTime.Parse(ds.Tables[0].Rows[0]["NOTIFY_TIME"].ToString());
				}
				if(ds.Tables[0].Rows[0]["NOTIFY_TYPE"]!=null && ds.Tables[0].Rows[0]["NOTIFY_TYPE"].ToString()!="")
				{
					this.NOTIFY_TYPE=ds.Tables[0].Rows[0]["NOTIFY_TYPE"].ToString();
				}
				if(ds.Tables[0].Rows[0]["SELLER_EMAIL"]!=null && ds.Tables[0].Rows[0]["SELLER_EMAIL"].ToString()!="")
				{
					this.SELLER_EMAIL=ds.Tables[0].Rows[0]["SELLER_EMAIL"].ToString();
				}
				if(ds.Tables[0].Rows[0]["BUYER_EMAIL"]!=null && ds.Tables[0].Rows[0]["BUYER_EMAIL"].ToString()!="")
				{
					this.BUYER_EMAIL=ds.Tables[0].Rows[0]["BUYER_EMAIL"].ToString();
				}
				if(ds.Tables[0].Rows[0]["SELLER_ID"]!=null && ds.Tables[0].Rows[0]["SELLER_ID"].ToString()!="")
				{
					this.SELLER_ID=ds.Tables[0].Rows[0]["SELLER_ID"].ToString();
				}
				if(ds.Tables[0].Rows[0]["BUYER_ID"]!=null && ds.Tables[0].Rows[0]["BUYER_ID"].ToString()!="")
				{
					this.BUYER_ID=ds.Tables[0].Rows[0]["BUYER_ID"].ToString();
				}
				if(ds.Tables[0].Rows[0]["TOTAL_FEE"]!=null && ds.Tables[0].Rows[0]["TOTAL_FEE"].ToString()!="")
				{
					this.TOTAL_FEE=decimal.Parse(ds.Tables[0].Rows[0]["TOTAL_FEE"].ToString());
				}
				if(ds.Tables[0].Rows[0]["BODY"]!=null && ds.Tables[0].Rows[0]["BODY"].ToString()!="")
				{
					this.BODY=ds.Tables[0].Rows[0]["BODY"].ToString();
				}
				if(ds.Tables[0].Rows[0]["EXTRA_COMMON_PARAM"]!=null && ds.Tables[0].Rows[0]["EXTRA_COMMON_PARAM"].ToString()!="")
				{
					this.EXTRA_COMMON_PARAM=ds.Tables[0].Rows[0]["EXTRA_COMMON_PARAM"].ToString();
				}
			}
		}

		/// <summary>
		/// 获得数据列表
		/// </summary>
		public DataSet GetList(string strWhere)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select * ");
			strSql.Append(" FROM T_ALIPAYNOTIFYSYN ");
			if(strWhere.Trim()!="")
			{
				strSql.Append(" where "+strWhere);
			}
			return DbHelperOra.Query(strSql.ToString());
		}

		#endregion  Method
	}
}

